Skip to main content

Following steps to create dataset using JSON

  • From this document, you will learn to create a dataset in OPNBI, Also you will learn to make a dataset using JSON.

What is JSON?​

  • JSON stands for JavaScript Object Notation. JSON is a text format for storing and transporting data. JSON is "self-describing" and easy to understand.

Objectives​

  • Create Dataset using JSON.

Prerequisites​

  • We are using employee(1).json for this example

Download json.zip file from link given json.zip

  • After downloading the zip file, add it into the OPNBI. To add it into OPNBI follow this Link

Skill Level Required​

  • Basic knowledge of JSON.
info

Click here to know more about JSON.

Steps to create dataset using JSON.​

  1. Click on Hamburger Manu > Document Tab > Shared Resources Tab.

    Docusaurus Slash Introduction

  2. In Shared Resource Click on upload, As shown in figure below:

    Docusaurus Slash Introduction

  • User will find json.zip from the start of this document. Use employee(1) file from that zip .

  1. When you click on Upload it will display a screen.

  2. In Upload Files upload a JSON file, As shown in figure below:

    Docusaurus Slash Introduction

  3. Click on Upload button

  4. You will get a message, As shown in figure below:

    Docusaurus Slash Introduction

  5. In Master Data Tab click on Dataset.

    Docusaurus Slash Introduction

  6. Click on create dataset, As shown in figure below:

    Docusaurus Slash Introduction

  7. Enter following details in Create Dataset.

  • Name: Employee JSON
  • Datasource: Existing Files
  • Select Employee(1).JSON file in Available to selected.

  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  1. Click on Select at the center of the screen.

  2. Click on Preview and submit button.

  3. You will see the Employee JSON Dataset, As shown in figure below:

    Docusaurus Slash Introduction

  4. Go to Hamburger menu > Dashboard Tab and open Dashboard.

    Docusaurus Slash Introduction

  5. From Right Vertical Menu Select the Table Widget icon.

    Docusaurus Slash Introduction

info
  • CLick here to know more about different dashboard widgets.

  1. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

  2. Enter Following Details in edit box, As shown in figure below:

  • Dataset: Employee Json.ds
  • Select all the Field in Dataset Column.

  1. Fill above details, As shown in figure below:

    Docusaurus Slash Introduction

  2. Click on Preview and Save and Exit.

  3. Now, match your Table Widget with the below example, it should look like the figure below:

    Docusaurus Slash Introduction

To know more about how to create dataset using different sources follow below Links:-

Dataset using CSV​

Dataset using Flatfiles​

Dataset using External sources​

Dataset using Excel​

Dataset using Google BigQuery​

Dataset using noSQL ​

Dataset using Join​

Dataset using Union​

Dataset using Server Script​

Dataset using Client Script​

Dataset using Stored Procedure​

Dataset using View​

Dataset using Simple Query​

Dataset using Drag & Drop​